Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	1070
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	159.0 KiB
Average record size in memory	152.1 B

Variable types

Numeric	13
Categorical	5
Boolean	1

Alerts

`WeekofPurchase` is highly overall correlated with `PriceCH` and 9 other fields	High correlation
`PriceCH` is highly overall correlated with `WeekofPurchase` and 13 other fields	High correlation
`PriceMM` is highly overall correlated with `WeekofPurchase` and 12 other fields	High correlation
`DiscCH` is highly overall correlated with `WeekofPurchase` and 8 other fields	High correlation
`DiscMM` is highly overall correlated with `WeekofPurchase` and 8 other fields	High correlation
`LoyalCH` is highly overall correlated with `Id` and 3 other fields	High correlation
`SalePriceMM` is highly overall correlated with `WeekofPurchase` and 12 other fields	High correlation
`SalePriceCH` is highly overall correlated with `WeekofPurchase` and 13 other fields	High correlation
`PriceDiff` is highly overall correlated with `WeekofPurchase` and 11 other fields	High correlation
`PctDiscMM` is highly overall correlated with `WeekofPurchase` and 11 other fields	High correlation
`PctDiscCH` is highly overall correlated with `WeekofPurchase` and 8 other fields	High correlation
`ListPriceDiff` is highly overall correlated with `WeekofPurchase` and 11 other fields	High correlation
`Purchase` is highly overall correlated with `LoyalCH`	High correlation
`StoreID` is highly overall correlated with `Id` and 9 other fields	High correlation
`SpecialCH` is highly overall correlated with `DiscCH` and 5 other fields	High correlation
`SpecialMM` is highly overall correlated with `PriceCH` and 4 other fields	High correlation
`Store7` is highly overall correlated with `StoreID` and 9 other fields	High correlation
`STORE` is highly overall correlated with `Id` and 9 other fields	High correlation
`Id` is highly overall correlated with `StoreID` and 2 other fields	High correlation
`Id` is uniformly distributed	Uniform
`Id` has unique values	Unique
`DiscCH` has 838 (78.3%) zeros	Zeros
`DiscMM` has 746 (69.7%) zeros	Zeros
`PriceDiff` has 75 (7.0%) zeros	Zeros
`PctDiscMM` has 746 (69.7%) zeros	Zeros
`PctDiscCH` has 838 (78.3%) zeros	Zeros
`ListPriceDiff` has 119 (11.1%) zeros	Zeros

Reproduction

Analysis started	2022-11-24 14:53:36.198993
Analysis finished	2022-11-24 14:54:09.143449
Duration	32.94 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

Id
Real number (ℝ)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	1070
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	535.5

Minimum	1
Maximum	1070
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1
5-th percentile	54.45
Q1	268.25
median	535.5
Q3	802.75
95-th percentile	1016.55
Maximum	1070
Range	1069
Interquartile range (IQR)	534.5

Descriptive statistics

Standard deviation	309.0267
Coefficient of variation (CV)	0.57708067
Kurtosis	-1.2
Mean	535.5
Median Absolute Deviation (MAD)	267.5
Skewness	0
Sum	572985
Variance	95497.5
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.1%
719	1	0.1%
705	1	0.1%
706	1	0.1%
707	1	0.1%
708	1	0.1%
709	1	0.1%
710	1	0.1%
711	1	0.1%
712	1	0.1%
Other values (1060)	1060	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%
10	1	0.1%

Value	Count	Frequency (%)
1070	1	0.1%
1069	1	0.1%
1068	1	0.1%
1067	1	0.1%
1066	1	0.1%
1065	1	0.1%
1064	1	0.1%
1063	1	0.1%
1062	1	0.1%
1061	1	0.1%

Purchase
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

CH	653
MM	417

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2140
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CH
2nd row	CH
3rd row	CH
4th row	MM
5th row	CH

Common Values

Value	Count	Frequency (%)
CH	653	61.0%
MM	417	39.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ch	653	61.0%
mm	417	39.0%

Most occurring characters

Value	Count	Frequency (%)
M	834	39.0%
C	653	30.5%
H	653	30.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2140	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	834	39.0%
C	653	30.5%
H	653	30.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2140	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	834	39.0%
C	653	30.5%
H	653	30.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2140	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	834	39.0%
C	653	30.5%
H	653	30.5%

WeekofPurchase
Real number (ℝ)

Distinct	52
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	254.38131

Minimum	227
Maximum	278
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	227
5-th percentile	229
Q1	240
median	257
Q3	268
95-th percentile	276
Maximum	278
Range	51
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.558286
Coefficient of variation (CV)	0.061161279
Kurtosis	-1.2749267
Mean	254.38131
Median Absolute Deviation (MAD)	14
Skewness	-0.21098982
Sum	272188
Variance	242.06027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
274	39	3.6%
275	33	3.1%
269	32	3.0%
259	31	2.9%
260	29	2.7%
233	28	2.6%
267	26	2.4%
266	26	2.4%
256	26	2.4%
265	26	2.4%
Other values (42)	774	72.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
227	15	1.4%
228	22	2.1%
229	23	2.1%
230	19	1.8%
231	20	1.9%
232	19	1.8%
233	28	2.6%
234	18	1.7%
235	16	1.5%
236	23	2.1%

Value	Count	Frequency (%)
278	18	1.7%
277	25	2.3%
276	26	2.4%
275	33	3.1%
274	39	3.6%
273	19	1.8%
272	25	2.3%
271	20	1.9%
270	23	2.1%
269	32	3.0%

StoreID
Categorical

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

7	356
2	222
3	196
1	157
4	139

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1070
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	7

Common Values

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring characters

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1070	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1070	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

PriceCH
Real number (ℝ)

Distinct	10
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8674206

Minimum	1.69
Maximum	2.09
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1.69
5-th percentile	1.69
Q1	1.79
median	1.86
Q3	1.99
95-th percentile	1.99
Maximum	2.09
Range	0.4
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.10196975
Coefficient of variation (CV)	0.0546046
Kurtosis	-0.77513258
Mean	1.8674206
Median Absolute Deviation (MAD)	0.1
Skewness	0.064415883
Sum	1998.14
Variance	0.01039783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1.86	376	35.1%
1.99	259	24.2%
1.79	101	9.4%
1.75	95	8.9%
1.69	94	8.8%
1.89	42	3.9%
1.76	40	3.7%
1.96	29	2.7%
2.09	27	2.5%
2.06	7	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.69	94	8.8%
1.75	95	8.9%
1.76	40	3.7%
1.79	101	9.4%
1.86	376	35.1%
1.89	42	3.9%
1.96	29	2.7%
1.99	259	24.2%
2.06	7	0.7%
2.09	27	2.5%

Value	Count	Frequency (%)
2.09	27	2.5%
2.06	7	0.7%
1.99	259	24.2%
1.96	29	2.7%
1.89	42	3.9%
1.86	376	35.1%
1.79	101	9.4%
1.76	40	3.7%
1.75	95	8.9%
1.69	94	8.8%

PriceMM
Real number (ℝ)

Distinct	8
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0854112

Minimum	1.69
Maximum	2.29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1.69
5-th percentile	1.69
Q1	1.99
median	2.09
Q3	2.18
95-th percentile	2.23
Maximum	2.29
Range	0.6
Interquartile range (IQR)	0.19

Descriptive statistics

Standard deviation	0.13438551
Coefficient of variation (CV)	0.064440774
Kurtosis	2.1839215
Mean	2.0854112
Median Absolute Deviation (MAD)	0.09
Skewness	-1.4618508
Sum	2231.39
Variance	0.018059466
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2.09	273	25.5%
2.18	201	18.8%
2.13	197	18.4%
1.99	179	16.7%
2.23	88	8.2%
1.69	57	5.3%
2.29	40	3.7%
1.79	35	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.69	57	5.3%
1.79	35	3.3%
1.99	179	16.7%
2.09	273	25.5%
2.13	197	18.4%
2.18	201	18.8%
2.23	88	8.2%
2.29	40	3.7%

Value	Count	Frequency (%)
2.29	40	3.7%
2.23	88	8.2%
2.18	201	18.8%
2.13	197	18.4%
2.09	273	25.5%
1.99	179	16.7%
1.79	35	3.3%
1.69	57	5.3%

DiscCH
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.051859813

Minimum	0
Maximum	0.5
Zeros	838
Zeros (%)	78.3%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.37
Maximum	0.5
Range	0.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.11747419
Coefficient of variation (CV)	2.2652259
Kurtosis	4.9336362
Mean	0.051859813
Median Absolute Deviation (MAD)	0
Skewness	2.4163405
Sum	55.49
Variance	0.013800186
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	838	78.3%
0.1	74	6.9%
0.37	36	3.4%
0.27	29	2.7%
0.47	21	2.0%
0.2	21	2.0%
0.13	21	2.0%
0.5	12	1.1%
0.3	6	0.6%
0.24	5	0.5%
Other values (2)	7	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	838	78.3%
0.1	74	6.9%
0.13	21	2.0%
0.16	5	0.5%
0.17	2	0.2%
0.2	21	2.0%
0.24	5	0.5%
0.27	29	2.7%
0.3	6	0.6%
0.37	36	3.4%

Value	Count	Frequency (%)
0.5	12	1.1%
0.47	21	2.0%
0.37	36	3.4%
0.3	6	0.6%
0.27	29	2.7%
0.24	5	0.5%
0.2	21	2.0%
0.17	2	0.2%
0.16	5	0.5%
0.13	21	2.0%

DiscMM
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12336449

Minimum	0
Maximum	0.8
Zeros	746
Zeros (%)	69.7%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.23
95-th percentile	0.54
Maximum	0.8
Range	0.8
Interquartile range (IQR)	0.23

Descriptive statistics

Standard deviation	0.21383375
Coefficient of variation (CV)	1.7333493
Kurtosis	1.4920999
Mean	0.12336449
Median Absolute Deviation (MAD)	0
Skewness	1.5947836
Sum	132
Variance	0.045724872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	746	69.7%
0.4	132	12.3%
0.54	42	3.9%
0.2	32	3.0%
0.3	29	2.7%
0.8	26	2.4%
0.24	18	1.7%
0.06	15	1.4%
0.74	10	0.9%
0.1	9	0.8%
Other values (2)	11	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	746	69.7%
0.06	15	1.4%
0.1	9	0.8%
0.2	32	3.0%
0.24	18	1.7%
0.3	29	2.7%
0.4	132	12.3%
0.54	42	3.9%
0.6	6	0.6%
0.7	5	0.5%

Value	Count	Frequency (%)
0.8	26	2.4%
0.74	10	0.9%
0.7	5	0.5%
0.6	6	0.6%
0.54	42	3.9%
0.4	132	12.3%
0.3	29	2.7%
0.24	18	1.7%
0.2	32	3.0%
0.1	9	0.8%

SpecialCH
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

0	912
1	158

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1070
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

Most occurring characters

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1070	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1070	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	912	85.2%
1	158	14.8%

SpecialMM
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

0	897
1	173

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1070
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

Most occurring characters

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1070	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1070	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	897	83.8%
1	173	16.2%

LoyalCH
Real number (ℝ)

Distinct	553
Distinct (%)	51.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.56578233

Minimum	1.1 × 10^-5
Maximum	0.999947
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1.1 × 10^-5
5-th percentile	0.009007
Q1	0.32525725
median	0.6
Q3	0.85087275
95-th percentile	0.98535265
Maximum	0.999947
Range	0.999936
Interquartile range (IQR)	0.5256155

Descriptive statistics

Standard deviation	0.30784253
Coefficient of variation (CV)	0.54410064
Kurtosis	-1.0598373
Mean	0.56578233
Median Absolute Deviation (MAD)	0.2616135
Skewness	-0.2788888
Sum	605.38709
Variance	0.094767023
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.5	61	5.7%
0.6	54	5.0%
0.4	50	4.7%
0.68	28	2.6%
0.32	25	2.3%
0.256	16	1.5%
0.744	16	1.5%
0.7952	15	1.4%
0.2048	12	1.1%
0.48	12	1.1%
Other values (543)	781	73.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.1 × 10^-5	1	0.1%
1.4 × 10^-5	1	0.1%
1.7 × 10^-5	1	0.1%
2.2 × 10^-5	1	0.1%
2.7 × 10^-5	1	0.1%
3.4 × 10^-5	1	0.1%
4.3 × 10^-5	1	0.1%
5.3 × 10^-5	1	0.1%
6.6 × 10^-5	1	0.1%
8.3 × 10^-5	1	0.1%

Value	Count	Frequency (%)
0.999947	1	0.1%
0.999934	1	0.1%
0.999917	1	0.1%
0.999896	1	0.1%
0.99987	1	0.1%
0.999838	1	0.1%
0.999797	1	0.1%
0.999746	1	0.1%
0.999683	1	0.1%
0.999604	1	0.1%

SalePriceMM
Real number (ℝ)

Distinct	18
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9620467

Minimum	1.19
Maximum	2.29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1.19
5-th percentile	1.5305
Q1	1.69
median	2.09
Q3	2.13
95-th percentile	2.23
Maximum	2.29
Range	1.1
Interquartile range (IQR)	0.44

Descriptive statistics

Standard deviation	0.25269736
Coefficient of variation (CV)	0.12879273
Kurtosis	-0.51861837
Mean	1.9620467
Median Absolute Deviation (MAD)	0.1
Skewness	-0.79716439
Sum	2099.39
Variance	0.063855957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2.09	209	19.5%
2.18	144	13.5%
1.69	127	11.9%
2.13	127	11.9%
1.59	101	9.4%
2.23	88	8.2%
1.99	66	6.2%
1.89	44	4.1%
1.79	44	4.1%
2.29	33	3.1%
Other values (8)	87	8.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.19	7	0.7%
1.38	19	1.8%
1.39	10	0.9%
1.48	5	0.5%
1.49	13	1.2%
1.58	6	0.6%
1.59	101	9.4%
1.69	127	11.9%
1.78	12	1.1%
1.79	44	4.1%

Value	Count	Frequency (%)
2.29	33	3.1%
2.23	88	8.2%
2.18	144	13.5%
2.13	127	11.9%
2.12	15	1.4%
2.09	209	19.5%
1.99	66	6.2%
1.89	44	4.1%
1.79	44	4.1%
1.78	12	1.1%

SalePriceCH
Real number (ℝ)

Distinct	13
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.8155607

Minimum	1.39
Maximum	2.09
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	1.39
5-th percentile	1.49
Q1	1.75
median	1.86
Q3	1.89
95-th percentile	1.99
Maximum	2.09
Range	0.7
Interquartile range (IQR)	0.14

Descriptive statistics

Standard deviation	0.14338359
Coefficient of variation (CV)	0.078974821
Kurtosis	0.95978822
Mean	1.8155607
Median Absolute Deviation (MAD)	0.1
Skewness	-0.95265054
Sum	1942.65
Variance	0.020558853
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1.86	273	25.5%
1.99	183	17.1%
1.89	101	9.4%
1.79	101	9.4%
1.75	95	8.9%
1.69	90	8.4%
1.76	76	7.1%
1.49	48	4.5%
1.59	34	3.2%
1.96	29	2.7%
Other values (3)	40	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.39	27	2.5%
1.49	48	4.5%
1.59	34	3.2%
1.69	90	8.4%
1.75	95	8.9%
1.76	76	7.1%
1.79	101	9.4%
1.86	273	25.5%
1.89	101	9.4%
1.96	29	2.7%

Value	Count	Frequency (%)
2.09	6	0.6%
2.06	7	0.7%
1.99	183	17.1%
1.96	29	2.7%
1.89	101	9.4%
1.86	273	25.5%
1.79	101	9.4%
1.76	76	7.1%
1.75	95	8.9%
1.69	90	8.4%

PriceDiff
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	36
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.14648598

Minimum	-0.67
Maximum	0.64
Zeros	75
Zeros (%)	7.0%
Negative	239
Negative (%)	22.3%
Memory size	8.5 KiB

Quantile statistics

Minimum	-0.67
5-th percentile	-0.4
Q1	0
median	0.23
Q3	0.32
95-th percentile	0.54
Maximum	0.64
Range	1.31
Interquartile range (IQR)	0.32

Descriptive statistics

Standard deviation	0.27156269
Coefficient of variation (CV)	1.8538476
Kurtosis	0.46593925
Mean	0.14648598
Median Absolute Deviation (MAD)	0.1
Skewness	-0.75977786
Sum	156.74
Variance	0.073746293
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
0.3	112	10.5%
0.32	111	10.4%
0.2	96	9.0%
0.24	94	8.8%
0	75	7.0%
0.64	48	4.5%
-0.16	46	4.3%
0.03	40	3.7%
0.33	37	3.5%
-0.2	37	3.5%
Other values (26)	374	35.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.67	7	0.7%
-0.58	19	1.8%
-0.57	10	0.9%
-0.4	24	2.2%
-0.38	5	0.5%
-0.3	22	2.1%
-0.28	6	0.6%
-0.27	3	0.3%
-0.2	37	3.5%
-0.17	19	1.8%

Value	Count	Frequency (%)
0.64	48	4.5%
0.54	29	2.7%
0.44	24	2.2%
0.42	20	1.9%
0.4	2	0.2%
0.38	5	0.5%
0.33	37	3.5%
0.32	111	10.4%
0.3	112	10.5%
0.27	36	3.4%

Store7
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 KiB

False	714
True	356

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	714	66.7%
True	356	33.3%

PctDiscMM
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	18
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.059298436

Minimum	0
Maximum	0.40201
Zeros	746
Zeros (%)	69.7%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.112676
95-th percentile	0.253521
Maximum	0.40201
Range	0.40201
Interquartile range (IQR)	0.112676

Descriptive statistics

Standard deviation	0.10176004
Coefficient of variation (CV)	1.7160662
Kurtosis	1.2725805
Mean	0.059298436
Median Absolute Deviation (MAD)	0
Skewness	1.5394911
Sum	63.449326
Variance	0.010355106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0	746	69.7%
0.201005	59	5.5%
0.191388	54	5.0%
0.253521	42	3.9%
0.150754	29	2.7%
0.366972	19	1.8%
0.112676	18	1.7%
0.027523	15	1.4%
0.118343	13	1.2%
0.183486	12	1.1%
Other values (8)	63	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	746	69.7%
0.027523	15	1.4%
0.050251	9	0.8%
0.095694	10	0.9%
0.100503	9	0.8%
0.112676	18	1.7%
0.118343	13	1.2%
0.150754	29	2.7%
0.174672	7	0.7%
0.183486	12	1.1%

Value	Count	Frequency (%)
0.40201	7	0.7%
0.366972	19	1.8%
0.347418	10	0.9%
0.321101	5	0.5%
0.275229	6	0.6%
0.253521	42	3.9%
0.201005	59	5.5%
0.191388	54	5.0%
0.183486	12	1.1%
0.174672	7	0.7%

PctDiscCH
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	13
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.027313837

Minimum	0
Maximum	0.252688
Zeros	838
Zeros (%)	78.3%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.198925
Maximum	0.252688
Range	0.252688
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.062232404
Coefficient of variation (CV)	2.2784204
Kurtosis	4.8776958
Mean	0.027313837
Median Absolute Deviation (MAD)	0
Skewness	2.4223001
Sum	29.225806
Variance	0.0038728721
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	838	78.3%
0.050251	59	5.5%
0.198925	36	3.4%
0.145161	29	2.7%
0.252688	21	2.0%
0.095694	21	2.0%
0.068783	21	2.0%
0.053763	15	1.4%
0.251256	12	1.1%
0.177515	6	0.6%
Other values (3)	12	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	838	78.3%
0.050251	59	5.5%
0.053763	15	1.4%
0.068783	21	2.0%
0.091398	2	0.2%
0.091429	5	0.5%
0.095694	21	2.0%
0.120603	5	0.5%
0.145161	29	2.7%
0.177515	6	0.6%

Value	Count	Frequency (%)
0.252688	21	2.0%
0.251256	12	1.1%
0.198925	36	3.4%
0.177515	6	0.6%
0.145161	29	2.7%
0.120603	5	0.5%
0.095694	21	2.0%
0.091429	5	0.5%
0.091398	2	0.2%
0.068783	21	2.0%

ListPriceDiff
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	18
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21799065

Minimum	0
Maximum	0.44
Zeros	119
Zeros (%)	11.1%
Negative	0
Negative (%)	0.0%
Memory size	8.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.14
median	0.24
Q3	0.3
95-th percentile	0.32
Maximum	0.44
Range	0.44
Interquartile range (IQR)	0.16

Descriptive statistics

Standard deviation	0.10753545
Coefficient of variation (CV)	0.49330302
Kurtosis	-0.22899269
Mean	0.21799065
Median Absolute Deviation (MAD)	0.06
Skewness	-0.64520812
Sum	233.25
Variance	0.011563873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0.24	159	14.9%
0.32	149	13.9%
0.27	143	13.4%
0	119	11.1%
0.3	119	11.1%
0.1	105	9.8%
0.23	75	7.0%
0.14	37	3.5%
0.2	32	3.0%
0.13	28	2.6%
Other values (8)	104	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	119	11.1%
0.07	7	0.7%
0.1	105	9.8%
0.13	28	2.6%
0.14	37	3.5%
0.17	10	0.9%
0.19	13	1.2%
0.2	32	3.0%
0.22	19	1.8%
0.23	75	7.0%

Value	Count	Frequency (%)
0.44	24	2.2%
0.42	10	0.9%
0.33	11	1.0%
0.32	149	13.9%
0.3	119	11.1%
0.29	10	0.9%
0.27	143	13.4%
0.24	159	14.9%
0.23	75	7.0%
0.22	19	1.8%

STORE
Categorical

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.5 KiB

0	356
2	222
3	196
1	157
4	139

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1070
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring characters

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1070	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1070	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	356	33.3%
2	222	20.7%
3	196	18.3%
1	157	14.7%
4	139	13.0%

Auto

The auto setting is an interpretable pairwise column metric of the following mapping:

Variable_type-Variable_type : Method, Range
Categorical-Categorical : Cramer's V, [0,1]
Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
Numerical-Numerical : Spearman's ρ, [-1,1]

The number of bins used in the discretization for the Numerical-Categorical column pair can be changed using config.correlations["auto"].n_bins. The number of bins affects the granularity of the association you wish to measure.

This configuration uses the recommended metric for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Id	Purchase	WeekofPurchase	StoreID	PriceCH	PriceMM	DiscCH	DiscMM	SpecialCH	SpecialMM	LoyalCH	SalePriceMM	SalePriceCH	PriceDiff	Store7	PctDiscMM	PctDiscCH	ListPriceDiff	STORE
0	1	CH	237	1	1.75	1.99	0.00	0.0	0	0	0.500000	1.99	1.75	0.24	No	0.000000	0.000000	0.24	1
1	2	CH	239	1	1.75	1.99	0.00	0.3	0	1	0.600000	1.69	1.75	-0.06	No	0.150754	0.000000	0.24	1
2	3	CH	245	1	1.86	2.09	0.17	0.0	0	0	0.680000	2.09	1.69	0.40	No	0.000000	0.091398	0.23	1
3	4	MM	227	1	1.69	1.69	0.00	0.0	0	0	0.400000	1.69	1.69	0.00	No	0.000000	0.000000	0.00	1
4	5	CH	228	7	1.69	1.69	0.00	0.0	0	0	0.956535	1.69	1.69	0.00	Yes	0.000000	0.000000	0.00	0
5	6	CH	230	7	1.69	1.99	0.00	0.0	0	1	0.965228	1.99	1.69	0.30	Yes	0.000000	0.000000	0.30	0
6	7	CH	232	7	1.69	1.99	0.00	0.4	1	1	0.972182	1.59	1.69	-0.10	Yes	0.201005	0.000000	0.30	0
7	8	CH	234	7	1.75	1.99	0.00	0.4	1	0	0.977746	1.59	1.75	-0.16	Yes	0.201005	0.000000	0.24	0
8	9	CH	235	7	1.75	1.99	0.00	0.4	0	0	0.982197	1.59	1.75	-0.16	Yes	0.201005	0.000000	0.24	0
9	10	CH	238	7	1.75	1.99	0.00	0.4	0	0	0.985757	1.59	1.75	-0.16	Yes	0.201005	0.000000	0.24	0

	Id	Purchase	WeekofPurchase	StoreID	PriceCH	PriceMM	DiscCH	DiscMM	SpecialMM	LoyalCH	SalePriceMM	SalePriceCH	PriceDiff	Store7	PctDiscMM	PctDiscCH	ListPriceDiff	STORE
1060	1061	MM	236	1	1.75	1.99	0.0	0.00	0	0.695258	1.99	1.75	0.24	No	0.000000	0.000000	0.24	1
1061	1062	MM	242	1	1.86	1.99	0.0	0.30	1	0.556206	1.69	1.86	-0.17	No	0.150754	0.000000	0.13	1
1062	1063	MM	245	7	1.86	2.09	0.0	0.20	0	0.444965	1.89	1.86	0.03	Yes	0.095694	0.000000	0.23	0
1063	1064	CH	251	1	1.76	2.09	0.0	0.00	0	0.355972	2.09	1.76	0.33	No	0.000000	0.000000	0.33	1
1064	1065	CH	251	7	1.86	2.09	0.1	0.00	0	0.484778	2.09	1.76	0.33	Yes	0.000000	0.053763	0.23	0
1065	1066	CH	252	7	1.86	2.09	0.1	0.00	0	0.587822	2.09	1.76	0.33	Yes	0.000000	0.053763	0.23	0
1066	1067	CH	256	7	1.86	2.18	0.0	0.00	0	0.670258	2.18	1.86	0.32	Yes	0.000000	0.000000	0.32	0
1067	1068	MM	257	7	1.86	2.18	0.0	0.00	0	0.736206	2.18	1.86	0.32	Yes	0.000000	0.000000	0.32	0
1068	1069	CH	261	7	1.86	2.13	0.0	0.24	0	0.588965	1.89	1.86	0.03	Yes	0.112676	0.000000	0.27	0
1069	1070	CH	270	1	1.86	2.18	0.0	0.00	0	0.671172	2.18	1.86	0.32	No	0.000000	0.000000	0.32	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample